home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The PC-SIG Library 10
/
The PC-Sig Library - Shareware for the IBM PC and Compatibles (PC-SIG)(Tenth Edition Disks 1-2804)(1991).iso
/
PC_SIGCD
/
10
/
9
/
DISK1095.ZIP
/
README1.DOC
< prev
next >
Wrap
Text File
|
1990-12-05
|
15KB
|
365 lines
.po 2
FFFFFFFFFFFFF RRRRRRRRRRR EEEEEEEEEEEEE EEEEEEEEEEEEE
FFFFFFFFFFFFFFF RRRRRRRRRRRRRR EEEEEEEEEEEEEEE EEEEEEEEEEEEEEE
FFFF FFF RRRR RRRR EEEE EE EEEE EE
FFFF RRRR RRRR EEEE EEEE
FFFFFFFFFFFFFFFF RRRRRRRRRRRRRRRR EEEEEEEEEEEEEEEE EEEEEEEEEEEEEEEE
FFFFFFFFFFFFFFFF RRRRRRRRRRRRRR EEEEEEEEEEEEEEEE EEEEEEEEEEEEEEEE
FFFF FF RRRR RRRR EEEE EE EEEE EE
FFFF RRRR RRR EEEE EEEE
FFFF RRRR RRRR EEEE EEEE
FFFF RRRR RRRR EEEEE EEE EEEEEE EEEE
FFFFFF RRRRRR RRRRRRR EEEEEEEEEEEEEEE EEEEEEEEEEEEEE
FFFFF RRRRRR RRRRRRR EEEEEEEEE EEEEEEEEEEE
[ ] dBASE III Plus Educational Version Disks
[ ] dBASE III Plus Complete Busines System Source Code (over 300,000 bytes)
+ Documentation disk, requires only 2 360K floppy IBMPC 256K compatible.
[ ] Programmer Documentation Manual with flow charts, tree diagrams, etc for
dBASE III Plus Complete Busines System Source Code (over 300,000 bytes)
[ ] End-user Documentation Manual with flow charts, tree diagrams, etc for
dBASE III Plus Complete Busines System Source Code (over 300,000 bytes)
[ ] Instructor Documentation Manual with Review Questions & Answers, Class
Lecture Outlines, Quizzes, extensive Test Data Bank with answers
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
FOR RUSH ORDERS PLEASE CALL: 1-800-526-0485
.PA
DATA BASE MANAGEMENT A MICROCOMPUTER APPROACH: SUPPLEMENTS
----------------------------------------------------------
There are several supplements available to adopters of DATA BASE
MANAGEMENT A MICROCOMPUTER APPROACH by C. McNichols and S. Rushinek.
For desk copies of these materials please fill out the following form:
============================================================================
To:
Ms. Carol Sobol/ Mr. Dennis Hogan
College Division
Prentice Hall
Englewood Cliffs, NJ 07632
Phone: 1-800-526-0485 or
(201) 592-2243
Please send:
[ ] DATA BASE MANAGEMENT A MICROCOMPUTER APPROACH (19590-9)
by Charles W. McNichols and Sara F. Rushinek
[ ] Instructor's Manual - with chapter outlines, test bank, teaching
tips, solutions to questions and exercises, and transparency
masters.
[ ] Solutions to Exercises for Lessons 1 - 8 on Diskette
SMITH BIKE WORKS (SBW) SOFTWARE (includes Customer Information System,
Personnel System, Accounting, Inventory, and Production & Planning)
[ ] Source Code and documentation Disk for SBW
[ ] Clipper compiled version of SBW on disk
[ ] Programmer Manual with flowcharts, descriptions, calls & dictionaries
[ ] The above on disk
[ ] User & Student Study Guide - with questions and answers
[ ] The above on disk
[ ] Dbase III Plus (Educational Version) two 360k floppy diskettes
NAME_________________________________________________________________
DEPARTMENT___________________________________________________________
INSTITUTION__________________________________________________________
ADDRESS______________________________________________________________
CITY/STATE/ZIP_______________________________________________________
PHONE_(Office)_____________(Home)____________OFFICE HOURS____________
===========================================================================
.PA
Smith Bike Works Business System
--------------------------------
The disk labeled Smith Bike Works Project Disk is an integrated business
application using dBASE III Plus that is described and documented
in Chapters 6 through 11 of the text. The five modules that compose
Smith Bike Works include:
-Customer Information Systems
-Human Resource Management
-Accounting
-Inventory Management & Order Processing
-Production Planning & Operations
To run the System, you need to have the dbase disk in drive A and in
drive B the project disk. At the dot prompt of dBASE (.) type:
DO SYSMENU and press RETURN.
USER MANUAL
------------
The User & Programmer Manual describes Smith Bike Works in detail.
The user portion presents a step by step execution of the system
using the same data files that are on the project disk. The
students first execute the system with the aid of the manual and
answer the questions as they go along.
Since the manual displays all the screens of the system, you can
easily review Smith Bike Works without having a computer in the
classroom. The students can take notes in the manual itself.
Throughout the manual, questions are included assessing the
students' understanding of the system, data base design techniques,
and the dBASE programming language. Answers to these questions are
available at the end of the manual. These questions can be
assigned for homework or for in-class exercises and discussion.
A portion of the user manual is on this disk on the file called
USER.DOC.
The manual has a table of contents and a sample portion follows:
----------------------------------------------------------------
T A B L E O F C O N T E N T S
1. THE CUSTOMER INFORMATION SYSTEM..................................1-1
2. SYSTEM MENU......................................................2-1
2.1. CUSTOMER INFORMATION SYSTEM.................................2-1
2.1.1. THE CUSTOMER FILE MAINTENANCE........................2-5
2.1.2. PRINT CUSTOMER REPORT................................2-27
2.1.3. PRINTING MAILING LABELS..............................2-31
2.1.4. GENERATE FORM LETTER.................................2-34
2.1.5. CUSTOMER FILE CLEANUP................................2-37
2.1.6. MOVE PURCHASE AMOUNTS BACK ONE YEAR..................2-39
2.1.7. RETURNING TO SYSMENU.................................2-41
There is a summary list of all questions that appeared in the
manual that can be used as review questions as the following:
---------------------------------------------------------------
L I S T O F Q U E S T I O N S
2-1: Why do you want to type dbase at A>?.................................2-2
2-2: Why must a second disk be inserted?..................................2-2
2-3: Why must you type DO SYSMENU?........................................2-3
2-4: What choice do you select to enter the customer information ...2-4
2-5: What does the customer file maintenance do?..........................2-5
2-6: What does the Find command do?.......................................2-6
2-7: Why must you type Ctrl-Y?............................................2-7
2-8: How does the system search for the customer requested?...............2-8
2-9: What choice will allow you to add a record?..........................2-9
.
2-11: How many possible indexes are there for the CUSTOMER file?..........2-11
A pictorial fool proof key stroke by keystroke demonstration of Smith
Bike Works follows:
---------------------------------------------------
1.2. SYSMENU
The system menu controls entry into the Smith's Bikeworks subsystems.
SCREEN 1-4: Activity Menu
/-----------------------------------------------------------------------\
SMITH'S BIKEWORKS INFORMATION SYSTEM
>> Activity Menu <<
A. CUSTOMER INFORMATION System
B. HUMAN RESOURCES MANAGEMENT System
C. ACCOUNTING System
D. INVENTORY MANAGEMENT System
E. PRODUCTION PLANNING System
F. EXIT From Bikeworks' Information System
Press Letter Matching Desired Option
\-----------------------------------------------------------------------/
Look at the screen, and find the "Activity Menu".
To me, it shows that the computer (defaults and/or) expects me to
enter a choice between A and F.
Next, I want to type A, because I want to load the customer information
system.
TYPE: A
AND THE SYSTEM WILL: Activate the Customer Information System.
Numbered Open-ended Questions are throughout the text as follows:
-----------------------------------------------------------------
Q&A 1-4: How do you load the Customer Information System?
Programmer Manual
------------------
Before students make changes or enhancements to a system, they first
need to understand it. Therefore, the programmer's manual includes:
-flowcharts at the system and modular level,
-program descriptions within the five modules,
-program calls pointing to subsequent executions, and
-data dictionaries describing all fields and variables.
Students can use these as guides as they enhance this existing system
and/or as they develop their documentation for their own programs.
Example of system flowchart:
---------------------------
_____________
| |
| SYSMENU | Diagram for procedure SYSMENU
|_____________| in system SYSMENU.PRG
|
|
|------->--------.------->--------.------->--------.
| | | |
| ______|______ ______|______ ______|______
| | | | | | |
v | ACCOUNT | | BOM | | CUSTINFO |
| |_____________| |_____________| |_____________|
|
|
|------->--------.
| |
______|______ ______|______
| | | |
| HRM | | INVEN |
|_____________| |_____________|
Example of program descriptions:
---------------------------------
Program: SYSMENU.PRG System Menu
Function: Entry point for the entire system, displays menu of
all subsystems and transfers control based on
operator input.
Called by: End-user from dBASE or DOS command level
Calls to: ACCOUNT.PRG
BOM.PRG
CUSTINFO.PRG
HRM.PRG
INVEN.PRG
Example of data structures and data dictionary follows:
-------------------------------------------------------
STRUCTURE AND DEFINITION OF DATABASE FILES
Structure for database: customer.dbf Customer Information file
Contents: This files contains specific information on each customer.
Size of each record: 178
Index files: NAME.NDX, COMPANY.NDX, ZIP.NDX
keys: LAST_NAME, COMPANY, ZIP
File structure:
Field Field Name Type Width Dec Description
1 LAST_NAME Character 20 Customer's last name
2 FIRST_NAME Character 15 Customer's first name
3 INITIAL Character 1 Customer's middle initial
4 TITLE Character 20 Customer's job title
5 COMPANY Character 25 Company's name
6 STREET Character 25 Company's street address
7 CITY Character 15 Company's city
8 STATE Character 2 Company's state
Instructor Manual
-----------------
An instructor's manual includes:
-detailed chapter outlines,
-solutions to all questions in the textbook,
-transparency masters, and
-a comprehensive test bank with an instructor key.
Teaching tips are included for each chapter. There are many
detailed suggested projects appropriate for students of various
programming levels.
Lesson & Exercise Solutions
---------------------------
The execution of lessons 1 through 8 from Chapter 5 are available
on disk. They were created in dBASE using alternate "txt" files
and can be printed out using any editor or word processor.
Suggested solutions for the exercises at the end of each lesson
are on this disk as well as in the instructor manual.
dBASE III PLUS Disk - Educational Version
------------------------------------------
For adopters of DATA BASE MANAGEMENT A MICROCOMPUTER APPROACH,
the educational version of dBASEIII Plus is available free of
charge from Prentice Hall. This version works in the same manner as
the full blown version, the only restriction is 31 records per
file. The Smith Bike Works System works on either the educational
or full version of dBASEIII Plus or dBASEIII.
Ordering Information
--------------------
For further information or to order examination copies of the text
or any of the supplementary materials, please write or call:
Ms. Carol Sobol/ Mr. Dennis Hogan
Prentice Hall Building
Prentice Hall
Englewood Cliffs, NJ 07632
Phone: 1-800-526-0485 or
(201) 592-2243
Comments & Suggestions
----------------------
Please feel free to contact us if you have any questions,
comments or suggestions about the text or the supplemental
materials. Specifically, we would like to know:
What improvements would you suggest?
How would you evaluate the text and the supplementary materials?
Please be honest in your comments. Your frank evaluation is requested.
Dr. Sara Rushinek Dr. Chuck McNichols
University of Miami Clemson University
MAS Department Management Department
417 Jenkins Building 101 Sirrine Hall
Coral Gables, Florida 33124 Clemson, SC 29634-1305
(305) 284-6595 Office (803) 656-3762 Office
(305) 666-7890 Home (803) 654-9590 Home